Overview
Brought to you by YData
Dataset statistics
| Number of variables | 22 |
|---|---|
| Number of observations | 15222 |
| Missing cells | 39966 |
| Missing cells (%) | 11.9% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 2.6 MiB |
| Average record size in memory | 176.0 B |
Variable types
| Numeric | 7 |
|---|---|
| DateTime | 3 |
| Categorical | 9 |
| Text | 2 |
| Unsupported | 1 |
Paiement has constant value "Carte prépayée" | Constant |
Role has constant value "Caissier" | Constant |
Statut has constant value "Validé" | Constant |
Client is highly overall correlated with ID_Client and 6 other fields | High correlation |
ID_Client is highly overall correlated with Client and 6 other fields | High correlation |
ID_Operation is highly overall correlated with Client and 5 other fields | High correlation |
ID_Restaurant is highly overall correlated with Client and 6 other fields | High correlation |
ID_User is highly overall correlated with Client and 5 other fields | High correlation |
Montant_Rgl is highly overall correlated with Montant_Versé | High correlation |
Montant_Versé is highly overall correlated with Montant_Rgl | High correlation |
Prenom User is highly overall correlated with Client and 5 other fields | High correlation |
Restaurant is highly overall correlated with Client and 6 other fields | High correlation |
Référence is highly overall correlated with Client and 3 other fields | High correlation |
ID_Client is highly imbalanced (63.9%) | Imbalance |
Client is highly imbalanced (63.9%) | Imbalance |
Référence has 15123 (99.3%) missing values | Missing |
ID_Client has 4532 (29.8%) missing values | Missing |
Client has 4532 (29.8%) missing values | Missing |
Bénéficiaire_CPP has 554 (3.6%) missing values | Missing |
Pointage has 15222 (100.0%) missing values | Missing |
Montant_Rst is highly skewed (γ1 = -45.24081811) | Skewed |
ID_Règlement has unique values | Unique |
ID_Operation has unique values | Unique |
Pointage is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Montant_Rst has 15137 (99.4%) zeros | Zeros |
Reproduction
| Analysis started | 2024-10-23 15:09:44.733242 |
|---|---|
| Analysis finished | 2024-10-23 15:09:56.669378 |
| Duration | 11.94 seconds |
| Software version | ydata-profiling vv4.11.0 |
| Download configuration | config.json |
Variables
ID_Règlement
Real number (ℝ)
Unique 
| Distinct | 15222 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 304552.63 |
| Minimum | 250355 |
|---|---|
| Maximum | 388034 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 119.1 KiB |
Quantile statistics
| Minimum | 250355 |
|---|---|
| 5-th percentile | 254054.1 |
| Q1 | 271202.75 |
| median | 299481.5 |
| Q3 | 334226.75 |
| 95-th percentile | 382797.8 |
| Maximum | 388034 |
| Range | 137679 |
| Interquartile range (IQR) | 63024 |
Descriptive statistics
| Standard deviation | 38098.098 |
|---|---|
| Coefficient of variation (CV) | 0.12509528 |
| Kurtosis | -0.79294062 |
| Mean | 304552.63 |
| Median Absolute Deviation (MAD) | 30849 |
| Skewness | 0.45270286 |
| Sum | 4.6359002 × 109 |
| Variance | 1.451465 × 109 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 388034 | 1 | < 0.1% |
| 287967 | 1 | < 0.1% |
| 287983 | 1 | < 0.1% |
| 287994 | 1 | < 0.1% |
| 282957 | 1 | < 0.1% |
| 282972 | 1 | < 0.1% |
| 286068 | 1 | < 0.1% |
| 286072 | 1 | < 0.1% |
| 286076 | 1 | < 0.1% |
| 286079 | 1 | < 0.1% |
| Other values (15212) | 15212 |
| Value | Count | Frequency (%) |
| 250355 | 1 | |
| 250356 | 1 | |
| 250358 | 1 | |
| 250364 | 1 | |
| 250365 | 1 | |
| 250367 | 1 | |
| 250372 | 1 | |
| 250377 | 1 | |
| 250384 | 1 | |
| 250386 | 1 |
| Value | Count | Frequency (%) |
| 388034 | 1 | |
| 388014 | 1 | |
| 387991 | 1 | |
| 387944 | 1 | |
| 387932 | 1 | |
| 387930 | 1 | |
| 387914 | 1 | |
| 387912 | 1 | |
| 387897 | 1 | |
| 387748 | 1 |
ID_Operation
Real number (ℝ)
High correlation  Unique 
| Distinct | 15222 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.4159311 × 108 |
| Minimum | 2.0190157 × 108 |
|---|---|
| Maximum | 9.0610577 × 108 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 119.1 KiB |
Quantile statistics
| Minimum | 2.0190157 × 108 |
|---|---|
| 5-th percentile | 4.0044006 × 108 |
| Q1 | 5.0051582 × 108 |
| median | 7.0087133 × 108 |
| Q3 | 7.0089721 × 108 |
| 95-th percentile | 9.0312642 × 108 |
| Maximum | 9.0610577 × 108 |
| Range | 7.042042 × 108 |
| Interquartile range (IQR) | 2.0038139 × 108 |
Descriptive statistics
| Standard deviation | 1.4827257 × 108 |
|---|---|
| Coefficient of variation (CV) | 0.23110062 |
| Kurtosis | -0.68986602 |
| Mean | 6.4159311 × 108 |
| Median Absolute Deviation (MAD) | 35857.5 |
| Skewness | -0.11835631 |
| Sum | 9.7663303 × 1012 |
| Variance | 2.1984754 × 1016 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 700915738 | 1 | < 0.1% |
| 700877295 | 1 | < 0.1% |
| 700877305 | 1 | < 0.1% |
| 700877312 | 1 | < 0.1% |
| 700874995 | 1 | < 0.1% |
| 700874999 | 1 | < 0.1% |
| 700876410 | 1 | < 0.1% |
| 700876413 | 1 | < 0.1% |
| 700876415 | 1 | < 0.1% |
| 700876417 | 1 | < 0.1% |
| Other values (15212) | 15212 |
| Value | Count | Frequency (%) |
| 201901567 | 1 | |
| 201901569 | 1 | |
| 201901571 | 1 | |
| 201901572 | 1 | |
| 201901573 | 1 | |
| 201901574 | 1 | |
| 400437757 | 1 | |
| 400437758 | 1 | |
| 400437759 | 1 | |
| 400437761 | 1 |
| Value | Count | Frequency (%) |
| 906105768 | 1 | |
| 906105735 | 1 | |
| 906105731 | 1 | |
| 906105705 | 1 | |
| 906105699 | 1 | |
| 906105698 | 1 | |
| 906105694 | 1 | |
| 906105691 | 1 | |
| 906105690 | 1 | |
| 906105689 | 1 |
Date_Règlement
Date
| Distinct | 243 |
|---|---|
| Distinct (%) | 1.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 119.1 KiB |
| Minimum | 2024-01-01 00:00:00 |
|---|---|
| Maximum | 2024-09-04 00:00:00 |
Heure_Règlement
Date
| Distinct | 12870 |
|---|---|
| Distinct (%) | 84.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 119.1 KiB |
| Minimum | 2024-10-23 01:09:21 |
|---|---|
| Maximum | 2024-10-23 23:47:44 |
Paiement
Categorical
Constant 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 119.1 KiB |
| Carte prépayée |
|---|
Length
| Max length | 14 |
|---|---|
| Median length | 14 |
| Mean length | 14 |
| Min length | 14 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Carte prépayée |
|---|---|
| 2nd row | Carte prépayée |
| 3rd row | Carte prépayée |
| 4th row | Carte prépayée |
| 5th row | Carte prépayée |
Common Values
| Value | Count | Frequency (%) |
| Carte prépayée | 15222 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| carte | 15222 | |
| prépayée | 15222 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 30444 | |
| é | 30444 | |
| r | 30444 | |
| e | 30444 | |
| p | 30444 | |
| C | 15222 | |
| t | 15222 | |
| 15222 | ||
| y | 15222 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 213108 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 30444 | |
| é | 30444 | |
| r | 30444 | |
| e | 30444 | |
| p | 30444 | |
| C | 15222 | |
| t | 15222 | |
| 15222 | ||
| y | 15222 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 213108 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 30444 | |
| é | 30444 | |
| r | 30444 | |
| e | 30444 | |
| p | 30444 | |
| C | 15222 | |
| t | 15222 | |
| 15222 | ||
| y | 15222 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 213108 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 30444 | |
| é | 30444 | |
| r | 30444 | |
| e | 30444 | |
| p | 30444 | |
| C | 15222 | |
| t | 15222 | |
| 15222 | ||
| y | 15222 |
Référence
Real number (ℝ)
High correlation  Missing 
| Distinct | 42 |
|---|---|
| Distinct (%) | 42.4% |
| Missing | 15123 |
| Missing (%) | 99.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.5411145 × 1015 |
| Minimum | 585 |
|---|---|
| Maximum | 9.9424452 × 1015 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 119.1 KiB |
Quantile statistics
| Minimum | 585 |
|---|---|
| 5-th percentile | 1.1327267 × 1015 |
| Q1 | 2.7593463 × 1015 |
| median | 4.2933584 × 1015 |
| Q3 | 9.4323998 × 1015 |
| 95-th percentile | 9.9283249 × 1015 |
| Maximum | 9.9424452 × 1015 |
| Range | 9.9424452 × 1015 |
| Interquartile range (IQR) | 6.6730535 × 1015 |
Descriptive statistics
| Standard deviation | 3.2404459 × 1015 |
|---|---|
| Coefficient of variation (CV) | 0.58480039 |
| Kurtosis | -1.4408955 |
| Mean | 5.5411145 × 1015 |
| Median Absolute Deviation (MAD) | 1.8670205 × 1015 |
| Skewness | 0.17979743 |
| Sum | 5.4857034 × 1017 |
| Variance | 1.050049 × 1031 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 3.751365738 × 1015 | 14 | 0.1% |
| 9.432399813 × 1015 | 12 | 0.1% |
| 2.426337889 × 1015 | 10 | 0.1% |
| 2.759346313 × 1015 | 8 | 0.1% |
| 5.798735672 × 1015 | 8 | 0.1% |
| 9.928324916 × 1015 | 4 | < 0.1% |
| 9.942445182 × 1015 | 4 | < 0.1% |
| 4.484248832 × 1015 | 2 | < 0.1% |
| 2.863716814 × 1015 | 2 | < 0.1% |
| 2.388218227 × 1015 | 2 | < 0.1% |
| Other values (32) | 33 | 0.2% |
| (Missing) | 15123 |
| Value | Count | Frequency (%) |
| 585 | 1 | < 0.1% |
| 904 | 1 | < 0.1% |
| 1246 | 1 | < 0.1% |
| 6024 | 1 | < 0.1% |
| 6537 | 1 | < 0.1% |
| 1.258585224 × 1015 | 1 | < 0.1% |
| 1.461162782 × 1015 | 1 | < 0.1% |
| 2.388218227 × 1015 | 2 | < 0.1% |
| 2.426337889 × 1015 | 10 | |
| 2.759346313 × 1015 | 8 |
| Value | Count | Frequency (%) |
| 9.942445182 × 1015 | 4 | < 0.1% |
| 9.928324916 × 1015 | 4 | < 0.1% |
| 9.921822518 × 1015 | 1 | < 0.1% |
| 9.867569317 × 1015 | 1 | < 0.1% |
| 9.854852615 × 1015 | 1 | < 0.1% |
| 9.854337879 × 1015 | 1 | < 0.1% |
| 9.849287978 × 1015 | 1 | < 0.1% |
| 9.694836984 × 1015 | 1 | < 0.1% |
| 9.484145895 × 1015 | 1 | < 0.1% |
| 9.432399813 × 1015 | 12 |
Montant_Rgl
Real number (ℝ)
High correlation 
| Distinct | 401 |
|---|---|
| Distinct (%) | 2.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 33.954553 |
| Minimum | 1.5 |
|---|---|
| Maximum | 2799.528 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 119.1 KiB |
Quantile statistics
| Minimum | 1.5 |
|---|---|
| 5-th percentile | 3.5 |
| Q1 | 10 |
| median | 24 |
| Q3 | 45 |
| 95-th percentile | 85 |
| Maximum | 2799.528 |
| Range | 2798.028 |
| Interquartile range (IQR) | 35 |
Descriptive statistics
| Standard deviation | 59.042239 |
|---|---|
| Coefficient of variation (CV) | 1.7388608 |
| Kurtosis | 657.75272 |
| Mean | 33.954553 |
| Median Absolute Deviation (MAD) | 16 |
| Skewness | 19.732976 |
| Sum | 516856.2 |
| Variance | 3485.986 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 50 | 997 | 6.5% |
| 40 | 728 | 4.8% |
| 15 | 706 | 4.6% |
| 10 | 612 | 4.0% |
| 30 | 543 | 3.6% |
| 8 | 498 | 3.3% |
| 18 | 438 | 2.9% |
| 20 | 421 | 2.8% |
| 45 | 410 | 2.7% |
| 5 | 383 | 2.5% |
| Other values (391) | 9486 |
| Value | Count | Frequency (%) |
| 1.5 | 116 | 0.8% |
| 2 | 317 | |
| 2.5 | 62 | 0.4% |
| 3 | 200 | |
| 3.5 | 115 | 0.8% |
| 4 | 333 | |
| 4.5 | 152 | 1.0% |
| 5 | 383 | |
| 5.5 | 146 | 1.0% |
| 6 | 203 |
| Value | Count | Frequency (%) |
| 2799.527996 | 1 | |
| 2373.942528 | 1 | |
| 1800 | 1 | |
| 1589.951992 | 1 | |
| 1574.750015 | 1 | |
| 1380.32 | 1 | |
| 1292.47821 | 1 | |
| 1005 | 1 | |
| 974.9080048 | 1 | |
| 971.57201 | 1 |
Montant_Versé
Real number (ℝ)
High correlation 
| Distinct | 400 |
|---|---|
| Distinct (%) | 2.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 33.954553 |
| Minimum | 1.5 |
|---|---|
| Maximum | 2799.5281 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 119.1 KiB |
Quantile statistics
| Minimum | 1.5 |
|---|---|
| 5-th percentile | 3.5 |
| Q1 | 10 |
| median | 24 |
| Q3 | 45 |
| 95-th percentile | 85 |
| Maximum | 2799.5281 |
| Range | 2798.0281 |
| Interquartile range (IQR) | 35 |
Descriptive statistics
| Standard deviation | 59.04224 |
|---|---|
| Coefficient of variation (CV) | 1.7388608 |
| Kurtosis | 657.75276 |
| Mean | 33.954553 |
| Median Absolute Deviation (MAD) | 16 |
| Skewness | 19.732977 |
| Sum | 516856.2 |
| Variance | 3485.9861 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 50 | 997 | 6.5% |
| 40 | 728 | 4.8% |
| 15 | 706 | 4.6% |
| 10 | 612 | 4.0% |
| 30 | 543 | 3.6% |
| 8 | 498 | 3.3% |
| 18 | 438 | 2.9% |
| 20 | 421 | 2.8% |
| 45 | 410 | 2.7% |
| 5 | 383 | 2.5% |
| Other values (390) | 9486 |
| Value | Count | Frequency (%) |
| 1.5 | 116 | 0.8% |
| 2 | 317 | |
| 2.5 | 62 | 0.4% |
| 3 | 200 | |
| 3.5 | 115 | 0.8% |
| 4 | 333 | |
| 4.5 | 152 | 1.0% |
| 5 | 383 | |
| 5.5 | 146 | 1.0% |
| 6 | 203 |
| Value | Count | Frequency (%) |
| 2799.528076 | 1 | |
| 2373.942627 | 1 | |
| 1800 | 1 | |
| 1589.952026 | 1 | |
| 1574.75 | 1 | |
| 1380.319946 | 1 | |
| 1292.478271 | 1 | |
| 1005 | 1 | |
| 974.90802 | 1 | |
| 971.5720215 | 1 |
Montant_Rst
Real number (ℝ)
Skewed  Zeros 
| Distinct | 59 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -1.4065161 × 10-8 |
| Minimum | -9.9182125 × 10-5 |
|---|---|
| Maximum | 5.3405757 × 10-5 |
| Zeros | 15137 |
| Zeros (%) | 99.4% |
| Negative | 36 |
| Negative (%) | 0.2% |
| Memory size | 119.1 KiB |
Quantile statistics
| Minimum | -9.9182125 × 10-5 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 5.3405757 × 10-5 |
| Range | 0.00015258788 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 1.3204659 × 10-6 |
|---|---|
| Coefficient of variation (CV) | -93.882029 |
| Kurtosis | 3499.9075 |
| Mean | -1.4065161 × 10-8 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -45.240818 |
| Sum | -0.00021409989 |
| Variance | 1.7436302 × 10-12 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 15137 | |
| 4.97379915 × 10-14 | 8 | 0.1% |
| 4.618527782 × 10-14 | 8 | 0.1% |
| -3.730349363 × 10-14 | 4 | < 0.1% |
| -3.97903932 × 10-13 | 3 | < 0.1% |
| -2.486899575 × 10-14 | 2 | < 0.1% |
| -7.105427358 × 10-15 | 2 | < 0.1% |
| -7.629394389 × 10-6 | 2 | < 0.1% |
| -7.629394986 × 10-6 | 2 | < 0.1% |
| 3.730349363 × 10-14 | 2 | < 0.1% |
| Other values (49) | 52 | 0.3% |
| Value | Count | Frequency (%) |
| -9.918212481 × 10-5 | 1 | |
| -8.010864485 × 10-5 | 1 | |
| -6.103515511 × 10-5 | 1 | |
| -3.433227744 × 10-5 | 1 | |
| -1.525878952 × 10-5 | 1 | |
| -1.525878929 × 10-5 | 1 | |
| -1.144409202 × 10-5 | 1 | |
| -7.629394986 × 10-6 | 2 | |
| -7.629394389 × 10-6 | 2 | |
| -7.629394247 × 10-6 | 1 |
| Value | Count | Frequency (%) |
| 5.34057574 × 10-5 | 1 | |
| 2.288818371 × 10-5 | 1 | |
| 2.288818325 × 10-5 | 1 | |
| 1.525878997 × 10-5 | 1 | |
| 1.144409225 × 10-5 | 1 | |
| 7.629394986 × 10-6 | 1 | |
| 7.629394304 × 10-6 | 1 | |
| 3.814696811 × 10-6 | 1 | |
| 2.145767255 × 10-6 | 1 | |
| 1.907349002 × 10-6 | 1 |
ID_Client
Categorical
High correlation  Imbalance  Missing 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 4532 |
| Missing (%) | 29.8% |
| Memory size | 119.1 KiB |
| CLT10001 | |
|---|---|
| CLT10002 | 735 |
Length
| Max length | 8 |
|---|---|
| Median length | 8 |
| Mean length | 8 |
| Min length | 8 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | CLT10001 |
|---|---|
| 2nd row | CLT10001 |
| 3rd row | CLT10001 |
| 4th row | CLT10001 |
| 5th row | CLT10001 |
Common Values
| Value | Count | Frequency (%) |
| CLT10001 | 9955 | |
| CLT10002 | 735 | 4.8% |
| (Missing) | 4532 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| clt10001 | 9955 | |
| clt10002 | 735 | 6.9% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 32070 | |
| 1 | 20645 | |
| L | 10690 | 12.5% |
| C | 10690 | 12.5% |
| T | 10690 | 12.5% |
| 2 | 735 | 0.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 85520 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 32070 | |
| 1 | 20645 | |
| L | 10690 | 12.5% |
| C | 10690 | 12.5% |
| T | 10690 | 12.5% |
| 2 | 735 | 0.9% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 85520 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 32070 | |
| 1 | 20645 | |
| L | 10690 | 12.5% |
| C | 10690 | 12.5% |
| T | 10690 | 12.5% |
| 2 | 735 | 0.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 85520 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 32070 | |
| 1 | 20645 | |
| L | 10690 | 12.5% |
| C | 10690 | 12.5% |
| T | 10690 | 12.5% |
| 2 | 735 | 0.9% |
Client
Categorical
High correlation  Imbalance  Missing 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 4532 |
| Missing (%) | 29.8% |
| Memory size | 119.1 KiB |
| CLIENT AU COMPTANT | |
|---|---|
| CLIENT CARTE PRÉPAYÉE | 735 |
Length
| Max length | 21 |
|---|---|
| Median length | 18 |
| Mean length | 18.206268 |
| Min length | 18 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | CLIENT AU COMPTANT |
|---|---|
| 2nd row | CLIENT AU COMPTANT |
| 3rd row | CLIENT AU COMPTANT |
| 4th row | CLIENT AU COMPTANT |
| 5th row | CLIENT AU COMPTANT |
Common Values
| Value | Count | Frequency (%) |
| CLIENT AU COMPTANT | 9955 | |
| CLIENT CARTE PRÉPAYÉE | 735 | 4.8% |
| (Missing) | 4532 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| client | 10690 | |
| au | 9955 | |
| comptant | 9955 | |
| carte | 735 | 2.3% |
| prépayée | 735 | 2.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| T | 31335 | |
| 21380 | ||
| C | 21380 | |
| A | 21380 | |
| N | 20645 | |
| E | 12160 | 6.2% |
| P | 11425 | 5.9% |
| L | 10690 | 5.5% |
| I | 10690 | 5.5% |
| O | 9955 | 5.1% |
| Other values (5) | 23585 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 194625 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| T | 31335 | |
| 21380 | ||
| C | 21380 | |
| A | 21380 | |
| N | 20645 | |
| E | 12160 | 6.2% |
| P | 11425 | 5.9% |
| L | 10690 | 5.5% |
| I | 10690 | 5.5% |
| O | 9955 | 5.1% |
| Other values (5) | 23585 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 194625 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| T | 31335 | |
| 21380 | ||
| C | 21380 | |
| A | 21380 | |
| N | 20645 | |
| E | 12160 | 6.2% |
| P | 11425 | 5.9% |
| L | 10690 | 5.5% |
| I | 10690 | 5.5% |
| O | 9955 | 5.1% |
| Other values (5) | 23585 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 194625 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| T | 31335 | |
| 21380 | ||
| C | 21380 | |
| A | 21380 | |
| N | 20645 | |
| E | 12160 | 6.2% |
| P | 11425 | 5.9% |
| L | 10690 | 5.5% |
| I | 10690 | 5.5% |
| O | 9955 | 5.1% |
| Other values (5) | 23585 |
ID_CartePP
Text
| Distinct | 1007 |
|---|---|
| Distinct (%) | 6.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 119.1 KiB |
Length
| Max length | 19 |
|---|---|
| Median length | 16 |
| Mean length | 16.012416 |
| Min length | 5 |
Unique
| Unique | 212 ? |
|---|---|
| Unique (%) | 1.4% |
Sample
| 1st row | 1237736457745921 |
|---|---|
| 2nd row | 9854337878921188 |
| 3rd row | 4284648158394883 |
| 4th row | 3628329735567861 |
| 5th row | 9536648418398212 |
| Value | Count | Frequency (%) |
| 4284648158394883 | 278 | 1.8% |
| 1461162782251889 | 275 | 1.8% |
| 6632395296331911 | 249 | 1.6% |
| 2863716813744826 | 242 | 1.6% |
| 5676118786483647 | 239 | 1.6% |
| 2426337888522318 | 227 | 1.5% |
| 2298119326996171 | 213 | 1.4% |
| 1271645626186163 | 201 | 1.3% |
| 1443451317787646 | 197 | 1.3% |
| 1258585224496584 | 196 | 1.3% |
| Other values (997) | 12905 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 28792 | |
| 4 | 28680 | |
| 3 | 28423 | |
| 2 | 28229 | |
| 8 | 28178 | |
| 6 | 27496 | |
| 9 | 27268 | |
| 5 | 23403 | |
| 7 | 22266 | |
| 0 | 382 | 0.2% |
| Other values (11) | 624 | 0.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 243741 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1 | 28792 | |
| 4 | 28680 | |
| 3 | 28423 | |
| 2 | 28229 | |
| 8 | 28178 | |
| 6 | 27496 | |
| 9 | 27268 | |
| 5 | 23403 | |
| 7 | 22266 | |
| 0 | 382 | 0.2% |
| Other values (11) | 624 | 0.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 243741 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1 | 28792 | |
| 4 | 28680 | |
| 3 | 28423 | |
| 2 | 28229 | |
| 8 | 28178 | |
| 6 | 27496 | |
| 9 | 27268 | |
| 5 | 23403 | |
| 7 | 22266 | |
| 0 | 382 | 0.2% |
| Other values (11) | 624 | 0.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 243741 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1 | 28792 | |
| 4 | 28680 | |
| 3 | 28423 | |
| 2 | 28229 | |
| 8 | 28178 | |
| 6 | 27496 | |
| 9 | 27268 | |
| 5 | 23403 | |
| 7 | 22266 | |
| 0 | 382 | 0.2% |
| Other values (11) | 624 | 0.3% |
Bénéficiaire_CPP
Text
Missing 
| Distinct | 855 |
|---|---|
| Distinct (%) | 5.8% |
| Missing | 554 |
| Missing (%) | 3.6% |
| Memory size | 119.1 KiB |
Length
| Max length | 28 |
|---|---|
| Median length | 21 |
| Mean length | 8.8797382 |
| Min length | 2 |
Unique
| Unique | 164 ? |
|---|---|
| Unique (%) | 1.1% |
Sample
| 1st row | MOUMOUN |
|---|---|
| 2nd row | FARAIDI |
| 3rd row | RACHIDI Salah |
| 4th row | EL AZRAK |
| 5th row | ZERIOUEL |
| Value | Count | Frequency (%) |
| el | 2031 | 10.0% |
| mohamed | 821 | 4.1% |
| yao | 494 | 2.4% |
| salah | 295 | 1.5% |
| rachidi | 295 | 1.5% |
| djeth | 289 | 1.4% |
| doudouh | 272 | 1.3% |
| selmani | 255 | 1.3% |
| nait | 245 | 1.2% |
| yazza | 244 | 1.2% |
| Other values (911) | 14986 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 19759 | |
| I | 11027 | 8.5% |
| E | 10094 | 7.7% |
| O | 8133 | 6.2% |
| H | 7425 | 5.7% |
| L | 6887 | 5.3% |
| M | 6476 | 5.0% |
| U | 6454 | 5.0% |
| R | 5903 | 4.5% |
| D | 5784 | 4.4% |
| Other values (40) | 42306 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 130248 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 19759 | |
| I | 11027 | 8.5% |
| E | 10094 | 7.7% |
| O | 8133 | 6.2% |
| H | 7425 | 5.7% |
| L | 6887 | 5.3% |
| M | 6476 | 5.0% |
| U | 6454 | 5.0% |
| R | 5903 | 4.5% |
| D | 5784 | 4.4% |
| Other values (40) | 42306 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 130248 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 19759 | |
| I | 11027 | 8.5% |
| E | 10094 | 7.7% |
| O | 8133 | 6.2% |
| H | 7425 | 5.7% |
| L | 6887 | 5.3% |
| M | 6476 | 5.0% |
| U | 6454 | 5.0% |
| R | 5903 | 4.5% |
| D | 5784 | 4.4% |
| Other values (40) | 42306 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 130248 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 19759 | |
| I | 11027 | 8.5% |
| E | 10094 | 7.7% |
| O | 8133 | 6.2% |
| H | 7425 | 5.7% |
| L | 6887 | 5.3% |
| M | 6476 | 5.0% |
| U | 6454 | 5.0% |
| R | 5903 | 4.5% |
| D | 5784 | 4.4% |
| Other values (40) | 42306 |
Solde_CPP
Real number (ℝ)
| Distinct | 5346 |
|---|---|
| Distinct (%) | 35.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 631.31823 |
| Minimum | 1.5 |
|---|---|
| Maximum | 6000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 119.1 KiB |
Quantile statistics
| Minimum | 1.5 |
|---|---|
| 5-th percentile | 22.5 |
| Q1 | 100 |
| median | 330 |
| Q3 | 960.875 |
| 95-th percentile | 1904.3 |
| Maximum | 6000 |
| Range | 5998.5 |
| Interquartile range (IQR) | 860.875 |
Descriptive statistics
| Standard deviation | 671.6558 |
|---|---|
| Coefficient of variation (CV) | 1.0638942 |
| Kurtosis | 0.65377392 |
| Mean | 631.31823 |
| Median Absolute Deviation (MAD) | 279 |
| Skewness | 1.1439607 |
| Sum | 9609926.2 |
| Variance | 451121.51 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1903.1 | 108 | 0.7% |
| 100 | 102 | 0.7% |
| 1904.1 | 79 | 0.5% |
| 1903.3 | 63 | 0.4% |
| 1902.1 | 61 | 0.4% |
| 1903.11 | 59 | 0.4% |
| 1902.12 | 59 | 0.4% |
| 1903.12 | 58 | 0.4% |
| 1903.9 | 58 | 0.4% |
| 200 | 57 | 0.4% |
| Other values (5336) | 14518 |
| Value | Count | Frequency (%) |
| 1.5 | 3 | < 0.1% |
| 2 | 7 | < 0.1% |
| 2.5 | 9 | |
| 3 | 11 | |
| 3.14 | 1 | < 0.1% |
| 3.5 | 12 | |
| 4 | 7 | < 0.1% |
| 4.5 | 7 | < 0.1% |
| 5 | 20 | |
| 5.28 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 6000 | 1 | |
| 5000 | 1 | |
| 4995 | 1 | |
| 4955 | 1 | |
| 4946 | 1 | |
| 4940 | 1 | |
| 4905 | 1 | |
| 3945.63 | 1 | |
| 3881.57 | 1 | |
| 3406.5 | 1 |
ID_Restaurant
Categorical
High correlation 
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 119.1 KiB |
| RST10005 | |
|---|---|
| RST10003 | |
| RST10012 | |
| RST10010 | 641 |
| RST10014 | 528 |
| Other values (2) | 151 |
Length
| Max length | 8 |
|---|---|
| Median length | 8 |
| Mean length | 8 |
| Min length | 8 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | RST10005 |
|---|---|
| 2nd row | RST10005 |
| 3rd row | RST10005 |
| 4th row | RST10005 |
| 5th row | RST10005 |
Common Values
| Value | Count | Frequency (%) |
| RST10005 | 8152 | |
| RST10003 | 4639 | |
| RST10012 | 1111 | 7.3% |
| RST10010 | 641 | 4.2% |
| RST10014 | 528 | 3.5% |
| RST10006 | 94 | 0.6% |
| RST10004 | 57 | 0.4% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| rst10005 | 8152 | |
| rst10003 | 4639 | |
| rst10012 | 1111 | 7.3% |
| rst10010 | 641 | 4.2% |
| rst10014 | 528 | 3.5% |
| rst10006 | 94 | 0.6% |
| rst10004 | 57 | 0.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 44027 | |
| 1 | 17502 | 14.4% |
| S | 15222 | 12.5% |
| R | 15222 | 12.5% |
| T | 15222 | 12.5% |
| 5 | 8152 | 6.7% |
| 3 | 4639 | 3.8% |
| 2 | 1111 | 0.9% |
| 4 | 585 | 0.5% |
| 6 | 94 | 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 121776 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 44027 | |
| 1 | 17502 | 14.4% |
| S | 15222 | 12.5% |
| R | 15222 | 12.5% |
| T | 15222 | 12.5% |
| 5 | 8152 | 6.7% |
| 3 | 4639 | 3.8% |
| 2 | 1111 | 0.9% |
| 4 | 585 | 0.5% |
| 6 | 94 | 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 121776 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 44027 | |
| 1 | 17502 | 14.4% |
| S | 15222 | 12.5% |
| R | 15222 | 12.5% |
| T | 15222 | 12.5% |
| 5 | 8152 | 6.7% |
| 3 | 4639 | 3.8% |
| 2 | 1111 | 0.9% |
| 4 | 585 | 0.5% |
| 6 | 94 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 121776 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 44027 | |
| 1 | 17502 | 14.4% |
| S | 15222 | 12.5% |
| R | 15222 | 12.5% |
| T | 15222 | 12.5% |
| 5 | 8152 | 6.7% |
| 3 | 4639 | 3.8% |
| 2 | 1111 | 0.9% |
| 4 | 585 | 0.5% |
| 6 | 94 | 0.1% |
Restaurant
Categorical
High correlation 
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 119.1 KiB |
| Café - Boulangerie - Pâtisserie - Rabat | |
|---|---|
| Snack Pizzeria - Rabat | |
| L'Casis Cafétéria HCZ | |
| Lavomatic - Rabat | 641 |
| Epicerie - Rabat | 528 |
| Other values (2) | 151 |
Length
| Max length | 39 |
|---|---|
| Median length | 39 |
| Mean length | 30.717908 |
| Min length | 16 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Café - Boulangerie - Pâtisserie - Rabat |
|---|---|
| 2nd row | Café - Boulangerie - Pâtisserie - Rabat |
| 3rd row | Café - Boulangerie - Pâtisserie - Rabat |
| 4th row | Café - Boulangerie - Pâtisserie - Rabat |
| 5th row | Café - Boulangerie - Pâtisserie - Rabat |
Common Values
| Value | Count | Frequency (%) |
| Café - Boulangerie - Pâtisserie - Rabat | 8152 | |
| Snack Pizzeria - Rabat | 4639 | |
| L'Casis Cafétéria HCZ | 1111 | 7.3% |
| Lavomatic - Rabat | 641 | 4.2% |
| Epicerie - Rabat | 528 | 3.5% |
| Pharmacie & Parapharmacie - Rabat | 94 | 0.6% |
| Restaurant Gastronomique - Rabat | 57 | 0.4% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 30509 | ||
| rabat | 14111 | |
| boulangerie | 8152 | 9.8% |
| café | 8152 | 9.8% |
| pâtisserie | 8152 | 9.8% |
| snack | 4639 | 5.6% |
| pizzeria | 4639 | 5.6% |
| l'casis | 1111 | 1.3% |
| cafétéria | 1111 | 1.3% |
| hcz | 1111 | 1.3% |
| Other values (6) | 1471 | 1.8% |
Most occurring characters
| Value | Count | Frequency (%) |
| 67936 | ||
| a | 59154 | |
| e | 38605 | 8.3% |
| i | 37898 | 8.1% |
| - | 30415 | 6.5% |
| t | 24186 | 5.2% |
| r | 22978 | 4.9% |
| s | 18640 | 4.0% |
| R | 14168 | 3.0% |
| b | 14111 | 3.0% |
| Other values (27) | 139497 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 467588 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 67936 | ||
| a | 59154 | |
| e | 38605 | 8.3% |
| i | 37898 | 8.1% |
| - | 30415 | 6.5% |
| t | 24186 | 5.2% |
| r | 22978 | 4.9% |
| s | 18640 | 4.0% |
| R | 14168 | 3.0% |
| b | 14111 | 3.0% |
| Other values (27) | 139497 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 467588 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 67936 | ||
| a | 59154 | |
| e | 38605 | 8.3% |
| i | 37898 | 8.1% |
| - | 30415 | 6.5% |
| t | 24186 | 5.2% |
| r | 22978 | 4.9% |
| s | 18640 | 4.0% |
| R | 14168 | 3.0% |
| b | 14111 | 3.0% |
| Other values (27) | 139497 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 467588 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 67936 | ||
| a | 59154 | |
| e | 38605 | 8.3% |
| i | 37898 | 8.1% |
| - | 30415 | 6.5% |
| t | 24186 | 5.2% |
| r | 22978 | 4.9% |
| s | 18640 | 4.0% |
| R | 14168 | 3.0% |
| b | 14111 | 3.0% |
| Other values (27) | 139497 |
ID_User
Categorical
High correlation 
| Distinct | 13 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Memory size | 119.1 KiB |
| USR10004 | |
|---|---|
| USR10003 | |
| USR10008 | |
| USR10002 | |
| USR10001 | |
| Other values (8) |
Length
| Max length | 8 |
|---|---|
| Median length | 8 |
| Mean length | 8 |
| Min length | 8 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | USR10004 |
|---|---|
| 2nd row | USR10004 |
| 3rd row | USR10004 |
| 4th row | USR10004 |
| 5th row | USR10004 |
Common Values
| Value | Count | Frequency (%) |
| USR10004 | 4158 | |
| USR10003 | 3581 | |
| USR10008 | 2348 | |
| USR10002 | 1963 | |
| USR10001 | 797 | 5.2% |
| USR10022 | 641 | 4.2% |
| USR10023 | 515 | 3.4% |
| USR10024 | 361 | 2.4% |
| USR10029 | 324 | 2.1% |
| USR10027 | 235 | 1.5% |
| Other values (3) | 298 | 2.0% |
Length
| Value | Count | Frequency (%) |
| usr10004 | 4158 | |
| usr10003 | 3581 | |
| usr10008 | 2348 | |
| usr10002 | 1963 | |
| usr10001 | 797 | 5.2% |
| usr10022 | 641 | 4.2% |
| usr10023 | 515 | 3.4% |
| usr10024 | 361 | 2.4% |
| usr10029 | 324 | 2.1% |
| usr10027 | 235 | 1.5% |
| Other values (3) | 298 | 2.0% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 43493 | |
| 1 | 16018 | 13.2% |
| S | 15221 | 12.5% |
| U | 15221 | 12.5% |
| R | 15221 | 12.5% |
| 2 | 4774 | 3.9% |
| 4 | 4519 | 3.7% |
| 3 | 4300 | 3.5% |
| 8 | 2416 | 2.0% |
| 9 | 324 | 0.3% |
| Other values (2) | 261 | 0.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 121768 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 43493 | |
| 1 | 16018 | 13.2% |
| S | 15221 | 12.5% |
| U | 15221 | 12.5% |
| R | 15221 | 12.5% |
| 2 | 4774 | 3.9% |
| 4 | 4519 | 3.7% |
| 3 | 4300 | 3.5% |
| 8 | 2416 | 2.0% |
| 9 | 324 | 0.3% |
| Other values (2) | 261 | 0.2% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 121768 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 43493 | |
| 1 | 16018 | 13.2% |
| S | 15221 | 12.5% |
| U | 15221 | 12.5% |
| R | 15221 | 12.5% |
| 2 | 4774 | 3.9% |
| 4 | 4519 | 3.7% |
| 3 | 4300 | 3.5% |
| 8 | 2416 | 2.0% |
| 9 | 324 | 0.3% |
| Other values (2) | 261 | 0.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 121768 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 43493 | |
| 1 | 16018 | 13.2% |
| S | 15221 | 12.5% |
| U | 15221 | 12.5% |
| R | 15221 | 12.5% |
| 2 | 4774 | 3.9% |
| 4 | 4519 | 3.7% |
| 3 | 4300 | 3.5% |
| 8 | 2416 | 2.0% |
| 9 | 324 | 0.3% |
| Other values (2) | 261 | 0.2% |
Prenom User
Categorical
High correlation 
| Distinct | 12 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Memory size | 119.1 KiB |
| Souhail | |
|---|---|
| Hamza | |
| Soundoss | |
| Ayoub | |
| Fadwa | |
| Other values (7) |
Length
| Max length | 10 |
|---|---|
| Median length | 9 |
| Mean length | 6.5225018 |
| Min length | 5 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Hamza |
|---|---|
| 2nd row | Hamza |
| 3rd row | Hamza |
| 4th row | Hamza |
| 5th row | Hamza |
Common Values
| Value | Count | Frequency (%) |
| Souhail | 4311 | |
| Hamza | 4158 | |
| Soundoss | 3581 | |
| Ayoub | 797 | 5.2% |
| Fadwa | 641 | 4.2% |
| Abdelkarim | 515 | 3.4% |
| Morad | 361 | 2.4% |
| Moncef | 324 | 2.1% |
| Ayman | 235 | 1.5% |
| Abdelkrim | 204 | 1.3% |
| Other values (2) | 94 | 0.6% |
Length
| Value | Count | Frequency (%) |
| souhail | 4311 | |
| hamza | 4158 | |
| soundoss | 3581 | |
| ayoub | 797 | 5.2% |
| fadwa | 641 | 4.2% |
| abdelkarim | 515 | 3.4% |
| morad | 361 | 2.4% |
| moncef | 324 | 2.1% |
| ayman | 235 | 1.5% |
| abdelkrim | 204 | 1.3% |
| Other values (2) | 94 | 0.6% |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 15140 | |
| o | 13023 | |
| u | 8757 | 8.8% |
| S | 7892 | 7.9% |
| s | 7162 | 7.2% |
| d | 5370 | 5.4% |
| m | 5112 | 5.1% |
| i | 5030 | 5.1% |
| l | 5030 | 5.1% |
| h | 4311 | 4.3% |
| Other values (16) | 22452 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 99279 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 15140 | |
| o | 13023 | |
| u | 8757 | 8.8% |
| S | 7892 | 7.9% |
| s | 7162 | 7.2% |
| d | 5370 | 5.4% |
| m | 5112 | 5.1% |
| i | 5030 | 5.1% |
| l | 5030 | 5.1% |
| h | 4311 | 4.3% |
| Other values (16) | 22452 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 99279 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 15140 | |
| o | 13023 | |
| u | 8757 | 8.8% |
| S | 7892 | 7.9% |
| s | 7162 | 7.2% |
| d | 5370 | 5.4% |
| m | 5112 | 5.1% |
| i | 5030 | 5.1% |
| l | 5030 | 5.1% |
| h | 4311 | 4.3% |
| Other values (16) | 22452 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 99279 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 15140 | |
| o | 13023 | |
| u | 8757 | 8.8% |
| S | 7892 | 7.9% |
| s | 7162 | 7.2% |
| d | 5370 | 5.4% |
| m | 5112 | 5.1% |
| i | 5030 | 5.1% |
| l | 5030 | 5.1% |
| h | 4311 | 4.3% |
| Other values (16) | 22452 |
Role
Categorical
Constant 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Memory size | 119.1 KiB |
| Caissier |
|---|
Length
| Max length | 8 |
|---|---|
| Median length | 8 |
| Mean length | 8 |
| Min length | 8 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Caissier |
|---|---|
| 2nd row | Caissier |
| 3rd row | Caissier |
| 4th row | Caissier |
| 5th row | Caissier |
Common Values
| Value | Count | Frequency (%) |
| Caissier | 15221 | |
| (Missing) | 1 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| caissier | 15221 |
Most occurring characters
| Value | Count | Frequency (%) |
| s | 30442 | |
| i | 30442 | |
| a | 15221 | |
| C | 15221 | |
| e | 15221 | |
| r | 15221 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 121768 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| s | 30442 | |
| i | 30442 | |
| a | 15221 | |
| C | 15221 | |
| e | 15221 | |
| r | 15221 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 121768 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| s | 30442 | |
| i | 30442 | |
| a | 15221 | |
| C | 15221 | |
| e | 15221 | |
| r | 15221 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 121768 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| s | 30442 | |
| i | 30442 | |
| a | 15221 | |
| C | 15221 | |
| e | 15221 | |
| r | 15221 |
Statut
Categorical
Constant 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 119.1 KiB |
| Validé |
|---|
Length
| Max length | 6 |
|---|---|
| Median length | 6 |
| Mean length | 6 |
| Min length | 6 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Validé |
|---|---|
| 2nd row | Validé |
| 3rd row | Validé |
| 4th row | Validé |
| 5th row | Validé |
Common Values
| Value | Count | Frequency (%) |
| Validé | 15222 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| validé | 15222 |
Most occurring characters
| Value | Count | Frequency (%) |
| V | 15222 | |
| a | 15222 | |
| l | 15222 | |
| i | 15222 | |
| d | 15222 | |
| é | 15222 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 91332 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| V | 15222 | |
| a | 15222 | |
| l | 15222 | |
| i | 15222 | |
| d | 15222 | |
| é | 15222 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 91332 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| V | 15222 | |
| a | 15222 | |
| l | 15222 | |
| i | 15222 | |
| d | 15222 | |
| é | 15222 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 91332 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| V | 15222 | |
| a | 15222 | |
| l | 15222 | |
| i | 15222 | |
| d | 15222 | |
| é | 15222 |
Pointage
Unsupported
Missing  Rejected  Unsupported 
| Missing | 15222 |
|---|---|
| Missing (%) | 100.0% |
| Memory size | 119.1 KiB |
Date_Sys
Date
| Distinct | 243 |
|---|---|
| Distinct (%) | 1.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 119.1 KiB |
| Minimum | 2024-01-01 00:00:00 |
|---|---|
| Maximum | 2024-09-04 00:00:00 |
Interactions
Correlations
| Client | ID_Client | ID_Operation | ID_Restaurant | ID_Règlement | ID_User | Montant_Rgl | Montant_Rst | Montant_Versé | Prenom User | Restaurant | Référence | Solde_CPP | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Client | 1.000 | 0.999 | 0.891 | 1.000 | 0.122 | 0.999 | 0.155 | 0.130 | 0.155 | 1.000 | 1.000 | 0.962 | 0.093 |
| ID_Client | 0.999 | 1.000 | 0.891 | 1.000 | 0.122 | 0.999 | 0.155 | 0.130 | 0.155 | 1.000 | 1.000 | 0.962 | 0.093 |
| ID_Operation | 0.891 | 0.891 | 1.000 | 0.722 | 0.328 | 0.569 | -0.405 | 0.012 | -0.405 | 0.567 | 0.722 | 0.266 | -0.241 |
| ID_Restaurant | 1.000 | 1.000 | 0.722 | 1.000 | 0.311 | 0.893 | 0.246 | 0.155 | 0.246 | 0.892 | 1.000 | 0.510 | 0.155 |
| ID_Règlement | 0.122 | 0.122 | 0.328 | 0.311 | 1.000 | 0.271 | 0.088 | 0.017 | 0.088 | 0.270 | 0.311 | 0.278 | 0.098 |
| ID_User | 0.999 | 0.999 | 0.569 | 0.893 | 0.271 | 1.000 | 0.203 | 0.169 | 0.203 | 1.000 | 0.893 | 0.369 | 0.134 |
| Montant_Rgl | 0.155 | 0.155 | -0.405 | 0.246 | 0.088 | 0.203 | 1.000 | 0.002 | 1.000 | 0.203 | 0.246 | 0.120 | 0.305 |
| Montant_Rst | 0.130 | 0.130 | 0.012 | 0.155 | 0.017 | 0.169 | 0.002 | 1.000 | 0.002 | 0.169 | 0.155 | -0.145 | 0.008 |
| Montant_Versé | 0.155 | 0.155 | -0.405 | 0.246 | 0.088 | 0.203 | 1.000 | 0.002 | 1.000 | 0.203 | 0.246 | 0.120 | 0.305 |
| Prenom User | 1.000 | 1.000 | 0.567 | 0.892 | 0.270 | 1.000 | 0.203 | 0.169 | 0.203 | 1.000 | 0.892 | 0.423 | 0.134 |
| Restaurant | 1.000 | 1.000 | 0.722 | 1.000 | 0.311 | 0.893 | 0.246 | 0.155 | 0.246 | 0.892 | 1.000 | 0.510 | 0.155 |
| Référence | 0.962 | 0.962 | 0.266 | 0.510 | 0.278 | 0.369 | 0.120 | -0.145 | 0.120 | 0.423 | 0.510 | 1.000 | -0.058 |
| Solde_CPP | 0.093 | 0.093 | -0.241 | 0.155 | 0.098 | 0.134 | 0.305 | 0.008 | 0.305 | 0.134 | 0.155 | -0.058 | 1.000 |
Missing values
Sample
| ID_Règlement | ID_Operation | Date_Règlement | Heure_Règlement | Paiement | Référence | Montant_Rgl | Montant_Versé | Montant_Rst | ID_Client | Client | ID_CartePP | Bénéficiaire_CPP | Solde_CPP | ID_Restaurant | Restaurant | ID_User | Prenom User | Role | Statut | Pointage | Date_Sys | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 287967 | 700877295 | 2024-02-29 | 08:07:37 | Carte prépayée | NaN | 13.5 | 13.5 | 0.0 | CLT10001 | CLIENT AU COMPTANT | 1237736457745921 | MOUMOUN | 952.00 | RST10005 | Café - Boulangerie - Pâtisserie - Rabat | USR10004 | Hamza | Caissier | Validé | NaN | 2024-02-29 |
| 1 | 287983 | 700877305 | 2024-02-29 | 08:17:54 | Carte prépayée | NaN | 8.0 | 8.0 | 0.0 | CLT10001 | CLIENT AU COMPTANT | 9854337878921188 | FARAIDI | 921.51 | RST10005 | Café - Boulangerie - Pâtisserie - Rabat | USR10004 | Hamza | Caissier | Validé | NaN | 2024-02-29 |
| 2 | 287994 | 700877312 | 2024-02-29 | 08:23:33 | Carte prépayée | NaN | 20.0 | 20.0 | 0.0 | CLT10001 | CLIENT AU COMPTANT | 4284648158394883 | RACHIDI Salah | 790.00 | RST10005 | Café - Boulangerie - Pâtisserie - Rabat | USR10004 | Hamza | Caissier | Validé | NaN | 2024-02-29 |
| 3 | 282957 | 700874995 | 2024-02-22 | 11:19:17 | Carte prépayée | NaN | 87.0 | 87.0 | 0.0 | CLT10001 | CLIENT AU COMPTANT | 3628329735567861 | EL AZRAK | 346.23 | RST10005 | Café - Boulangerie - Pâtisserie - Rabat | USR10004 | Hamza | Caissier | Validé | NaN | 2024-02-22 |
| 4 | 282972 | 700874999 | 2024-02-22 | 11:31:14 | Carte prépayée | NaN | 5.0 | 5.0 | 0.0 | CLT10001 | CLIENT AU COMPTANT | 9536648418398212 | ZERIOUEL | 875.50 | RST10005 | Café - Boulangerie - Pâtisserie - Rabat | USR10004 | Hamza | Caissier | Validé | NaN | 2024-02-22 |
| 5 | 286068 | 700876410 | 2024-02-27 | 08:16:08 | Carte prépayée | NaN | 8.0 | 8.0 | 0.0 | CLT10001 | CLIENT AU COMPTANT | 3459944654116885 | CHAOUNI BENABDALLAH | 961.50 | RST10005 | Café - Boulangerie - Pâtisserie - Rabat | USR10004 | Hamza | Caissier | Validé | NaN | 2024-02-27 |
| 6 | 286072 | 700876413 | 2024-02-27 | 08:17:21 | Carte prépayée | NaN | 12.0 | 12.0 | 0.0 | CLT10001 | CLIENT AU COMPTANT | 1468957443591868 | ZAZARI | 185.00 | RST10005 | Café - Boulangerie - Pâtisserie - Rabat | USR10004 | Hamza | Caissier | Validé | NaN | 2024-02-27 |
| 7 | 286076 | 700876415 | 2024-02-27 | 08:17:59 | Carte prépayée | NaN | 8.0 | 8.0 | 0.0 | CLT10001 | CLIENT AU COMPTANT | 3459944654116885 | CHAOUNI BENABDALLAH | 953.50 | RST10005 | Café - Boulangerie - Pâtisserie - Rabat | USR10004 | Hamza | Caissier | Validé | NaN | 2024-02-27 |
| 8 | 286079 | 700876417 | 2024-02-27 | 08:19:31 | Carte prépayée | NaN | 45.0 | 45.0 | 0.0 | CLT10001 | CLIENT AU COMPTANT | 2984982456498383 | MAARIF | 331.00 | RST10005 | Café - Boulangerie - Pâtisserie - Rabat | USR10004 | Hamza | Caissier | Validé | NaN | 2024-02-27 |
| 9 | 288014 | 700877323 | 2024-02-29 | 08:34:11 | Carte prépayée | NaN | 8.0 | 8.0 | 0.0 | CLT10001 | CLIENT AU COMPTANT | 3417943491637353 | EZ-ZAARATE | 141.00 | RST10005 | Café - Boulangerie - Pâtisserie - Rabat | USR10004 | Hamza | Caissier | Validé | NaN | 2024-02-29 |
| ID_Règlement | ID_Operation | Date_Règlement | Heure_Règlement | Paiement | Référence | Montant_Rgl | Montant_Versé | Montant_Rst | ID_Client | Client | ID_CartePP | Bénéficiaire_CPP | Solde_CPP | ID_Restaurant | Restaurant | ID_User | Prenom User | Role | Statut | Pointage | Date_Sys | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15212 | 387748 | 906105705 | 2024-09-04 | 07:43:20 | Carte prépayée | NaN | 19.0 | 19.0 | 0.0 | CLT10001 | CLIENT AU COMPTANT | 9632819172214156 | DOUDOUH | 1903.30 | RST10014 | Epicerie - Rabat | USR10029 | Moncef | Caissier | Validé | NaN | 2024-09-04 |
| 15213 | 387897 | 906105731 | 2024-09-04 | 09:45:12 | Carte prépayée | NaN | 4.0 | 4.0 | 0.0 | CLT10001 | CLIENT AU COMPTANT | 9697966821673656 | CHERKAOUI | 13.50 | RST10014 | Epicerie - Rabat | USR10029 | Moncef | Caissier | Validé | NaN | 2024-09-04 |
| 15214 | 387912 | 700915703 | 2024-09-04 | 09:58:58 | Carte prépayée | NaN | 13.0 | 13.0 | 0.0 | CLT10001 | CLIENT AU COMPTANT | 9648732328734427 | HANAFI | 79.50 | RST10005 | Café - Boulangerie - Pâtisserie - Rabat | USR10004 | Hamza | Caissier | Validé | NaN | 2024-09-04 |
| 15215 | 387914 | 906105735 | 2024-09-04 | 10:00:14 | Carte prépayée | NaN | 19.0 | 19.0 | 0.0 | CLT10001 | CLIENT AU COMPTANT | 3657743229762819 | JENNANE | 74.50 | RST10014 | Epicerie - Rabat | USR10029 | Moncef | Caissier | Validé | NaN | 2024-09-04 |
| 15216 | 387930 | 700915709 | 2024-09-04 | 10:10:07 | Carte prépayée | NaN | 4.0 | 4.0 | 0.0 | CLT10001 | CLIENT AU COMPTANT | 9647665548393481 | HANINE Mohamed | 34.50 | RST10005 | Café - Boulangerie - Pâtisserie - Rabat | USR10004 | Hamza | Caissier | Validé | NaN | 2024-09-04 |
| 15217 | 387932 | 700915710 | 2024-09-04 | 10:10:28 | Carte prépayée | NaN | 7.0 | 7.0 | 0.0 | CLT10001 | CLIENT AU COMPTANT | 3314783631225925 | AQEL | 1453.55 | RST10005 | Café - Boulangerie - Pâtisserie - Rabat | USR10004 | Hamza | Caissier | Validé | NaN | 2024-09-04 |
| 15218 | 387944 | 700915716 | 2024-09-04 | 10:20:13 | Carte prépayée | NaN | 35.0 | 35.0 | 0.0 | CLT10001 | CLIENT AU COMPTANT | 9166242347522725 | AIT HAJJI | 6000.00 | RST10005 | Café - Boulangerie - Pâtisserie - Rabat | USR10004 | Hamza | Caissier | Validé | NaN | 2024-09-04 |
| 15219 | 387991 | 700915730 | 2024-09-04 | 10:52:03 | Carte prépayée | NaN | 54.0 | 54.0 | 0.0 | CLT10001 | CLIENT AU COMPTANT | 3391323398681767 | ZAGHBACH | 59.00 | RST10005 | Café - Boulangerie - Pâtisserie - Rabat | USR10004 | Hamza | Caissier | Validé | NaN | 2024-09-04 |
| 15220 | 388014 | 906105768 | 2024-09-04 | 11:16:27 | Carte prépayée | NaN | 5.0 | 5.0 | 0.0 | CLT10001 | CLIENT AU COMPTANT | 9364826446274539 | ZAHID | 66.00 | RST10014 | Epicerie - Rabat | USR10029 | Moncef | Caissier | Validé | NaN | 2024-09-04 |
| 15221 | 388034 | 700915738 | 2024-09-04 | 11:25:34 | Carte prépayée | NaN | 8.0 | 8.0 | 0.0 | CLT10001 | CLIENT AU COMPTANT | 9934258673758229 | REMMAL | 36.50 | RST10005 | Café - Boulangerie - Pâtisserie - Rabat | USR10004 | Hamza | Caissier | Validé | NaN | 2024-09-04 |